package com.test.web.excel.data.wz;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.math.BigDecimal;
/**
 * @author heyanjing
 * date:2020-05-08 2020/5/8:16:28
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
@ContentRowHeight(20)
@HeadRowHeight(40)
@ColumnWidth(16)
public class YearMonthWriteData {
    @ExcelProperty(value = {"网点"})
    private String     branchName;
    @ExcelProperty(value = {"一月"})
    private BigDecimal total01 = BigDecimal.ZERO;
    @ExcelProperty(value = {"二月"})
    private BigDecimal total02 = BigDecimal.ZERO;
    @ExcelProperty(value = {"三月"})
    private BigDecimal total03 = BigDecimal.ZERO;
    @ExcelProperty(value = {"四月"})
    private BigDecimal total04 = BigDecimal.ZERO;
    @ExcelProperty(value = {"五月"})
    private BigDecimal total05 = BigDecimal.ZERO;
    @ExcelProperty(value = {"六月"})
    private BigDecimal total06 = BigDecimal.ZERO;
    @ExcelProperty(value = {"七月"})
    private BigDecimal total07 = BigDecimal.ZERO;
    @ExcelProperty(value = {"八月"})
    private BigDecimal total08 = BigDecimal.ZERO;
    @ExcelProperty(value = {"九月"})
    private BigDecimal total09 = BigDecimal.ZERO;
    @ExcelProperty(value = {"十月"})
    private BigDecimal total10 = BigDecimal.ZERO;
    @ExcelProperty(value = {"十一月"})
    private BigDecimal total11 = BigDecimal.ZERO;
    @ExcelProperty(value = {"十二月"})
    private BigDecimal total12 = BigDecimal.ZERO;
    @ExcelProperty(value = {"合计"})
    private BigDecimal total;
    public BigDecimal getTotal() {
        return total01.add(total02).add(total03).add(total04).add(total05).add(total06).add(total07).add(total08).add(total09).add(total10).add(total11).add(total12);
    }
}
